<?xml version="1.0"?>
<CsvDataLoaderParams xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <TableMetadataEntity>
    <Name>Juvenile Arrests and Charges</Name>
    <Category>Public Safety</Category>
    <Description>Provides juvenile arrests and charges reported by the Metropolitan Police Department (MPDC), aggregated to block level</Description>
    <Source>DC Metropolitan Police Department</Source>
    <LastUpdateDate>2009-03-30T00:00:00</LastUpdateDate>
    <MetadataUrl>http://data.octo.dc.gov/Metadata.aspx?id=2</MetadataUrl>
    <EntitySet>JuvenileArrestsCharges</EntitySet>
    <EntityKind>JuvenileArrestCharge</EntityKind>
  </TableMetadataEntity>
  <ProducerParams>
    <PlacemarkParams>
      <LatitudeProperty>LATITUDE</LatitudeProperty>
      <LongitudeProperty>LONGITUDE</LongitudeProperty>
      <NamePropertyFormatString>{0}, {1}</NamePropertyFormatString>
      <NameProperties>
        <string>OFFENSEDESCRIPTION</string>
        <string>OFFENSEDATETIME</string>
      </NameProperties>
    </PlacemarkParams>
    <PropertyToTypeMap>
      <CHARGEID>string</CHARGEID>
      <DATEOFBIRTH>DateTime-YYYYMMDD</DATEOFBIRTH>
      <ARRESTDATETIME>DateTime</ARRESTDATETIME>
      <RACE>string</RACE>
      <GENDER>string</GENDER>
      <WEAPONCODE>string</WEAPONCODE>
      <WEAPONDESCRIPTION>string</WEAPONDESCRIPTION>
      <DRUGCODE>string</DRUGCODE>
      <DRUGDESCRIPTION>string</DRUGDESCRIPTION>
      <YEARSOFEDUCATION>double</YEARSOFEDUCATION>
      <MARITALSTATUS>string</MARITALSTATUS>
      <EMPLOYMENTSTATUS>string</EMPLOYMENTSTATUS>
      <ETHNICITY>string</ETHNICITY>
      <BOOKINGDATETIME>DateTime</BOOKINGDATETIME>
      <TACTICCODE>string</TACTICCODE>
      <TACTICDESCRIPTION>string</TACTICDESCRIPTION>
      <PREMISECODE>string</PREMISECODE>
      <PREMISEDESCRIPTION>string</PREMISEDESCRIPTION>
      <CELLBLOCKENTRYDATETIME>DateTime</CELLBLOCKENTRYDATETIME>
      <OFFENSECODE>string</OFFENSECODE>
      <OFFENSEDESCRIPTION>string</OFFENSEDESCRIPTION>
      <OFFENSEDATETIME>DateTime</OFFENSEDATETIME>
      <CHARGEDISPOSITIONCODE>string</CHARGEDISPOSITIONCODE>
      <CHARGEDISPOSITIONDESCRIPTION>string</CHARGEDISPOSITIONDESCRIPTION>
      <VICTIMRACE>string</VICTIMRACE>
      <VICTIMSEX>string</VICTIMSEX>
      <VICTIMAGE>string</VICTIMAGE>
      <CHARGENUMBER>int32</CHARGENUMBER>
      <LASTMODIFIEDDATE>DateTime</LASTMODIFIEDDATE>
      <LATITUDE>double</LATITUDE>
      <LONGITUDE>double</LONGITUDE>
      <BLOCKSITEADDRESS>string</BLOCKSITEADDRESS>
      <ZIPCODE>string</ZIPCODE>
      <DCSTATADDRESSKEY>string</DCSTATADDRESSKEY>
      <DCSTATLOCATIONKEY>string</DCSTATLOCATIONKEY>
      <WARD>string</WARD>
      <ANC>string</ANC>
      <SMD>string</SMD>
      <DISTRICT>string</DISTRICT>
      <PSA>string</PSA>
      <NEIGHBORHOODCLUSTER>string</NEIGHBORHOODCLUSTER>
      <HOTSPOT2006NAME>string</HOTSPOT2006NAME>
      <HOTSPOT2005NAME>string</HOTSPOT2005NAME>
      <HOTSPOT2004NAME>string</HOTSPOT2004NAME>
      <BUSINESSIMPROVEMENTDISTRICT>string</BUSINESSIMPROVEMENTDISTRICT>
    </PropertyToTypeMap>
  </ProducerParams>
  <ProcessorParams>
    <PartitionKeyPropertyName>ARRESTDATETIME</PartitionKeyPropertyName>
    <RowKeyPropertyName>CHARGEID</RowKeyPropertyName>
    <TableMetadataPartitionKeyPropertyName>Name</TableMetadataPartitionKeyPropertyName>
    <TableMetadataRowKeyPropertyName>New.Guid</TableMetadataRowKeyPropertyName>
    <EntityMetadataPartitionKeyPropertyName>EntitySet</EntityMetadataPartitionKeyPropertyName>
    <EntityMetadataRowKeyPropertyName>EntityKind</EntityMetadataRowKeyPropertyName>
  </ProcessorParams>
</CsvDataLoaderParams>